Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 97463 |
| Missing cells | 158882 |
| Missing cells (%) | 8.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 14.9 MiB |
| Average record size in memory | 160.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Categorical | 5 |
| Text | 6 |
| Unsupported | 1 |
| DateTime | 2 |
Fiscal_Year has constant value "" | Constant |
CheckVoidDt has constant value "" | Constant |
ObjectId is highly overall correlated with Budget_Type and 1 other fields | High correlation |
InvoiceID is highly overall correlated with CheckID | High correlation |
InvoiceAmt is highly overall correlated with DistributionAmt and 1 other fields | High correlation |
DistributionAmt is highly overall correlated with InvoiceAmt | High correlation |
CheckID is highly overall correlated with InvoiceID | High correlation |
CheckAmt is highly overall correlated with InvoiceAmt | High correlation |
Budget_Type is highly overall correlated with ObjectId and 1 other fields | High correlation |
Agency_Name is highly overall correlated with ObjectId and 1 other fields | High correlation |
Budget_Type is highly imbalanced (71.5%) | Imbalance |
Category is highly imbalanced (59.0%) | Imbalance |
DepartmentName has 5230 (5.4%) missing values | Missing |
Sub_DepartmentName has 56189 (57.7%) missing values | Missing |
Stimulus_Type has 97463 (100.0%) missing values | Missing |
InvoiceAmt is highly skewed (γ1 = 29.3232093) | Skewed |
DistributionAmt is highly skewed (γ1 = 60.85704035) | Skewed |
ObjectId is uniformly distributed | Uniform |
ObjectId has unique values | Unique |
Stimulus_Type is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2023-12-31 13:39:03.563754 |
|---|---|
| Analysis finished | 2023-12-31 13:39:19.610514 |
| Duration | 16.05 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
ObjectId
Real number (ℝ)
HIGH CORRELATION  UNIFORM  UNIQUE 
| Distinct | 97463 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48732 |
| Minimum | 1 |
|---|---|
| Maximum | 97463 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 761.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4874.1 |
| Q1 | 24366.5 |
| median | 48732 |
| Q3 | 73097.5 |
| 95-th percentile | 92589.9 |
| Maximum | 97463 |
| Range | 97462 |
| Interquartile range (IQR) | 48731 |
Descriptive statistics
| Standard deviation | 28135.289 |
|---|---|
| Coefficient of variation (CV) | 0.57734731 |
| Kurtosis | -1.2 |
| Mean | 48732 |
| Median Absolute Deviation (MAD) | 24366 |
| Skewness | 0 |
| Sum | 4.7495669 × 109 |
| Variance | 7.9159449 × 108 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 64973 | 1 | < 0.1% |
| 64982 | 1 | < 0.1% |
| 64981 | 1 | < 0.1% |
| 64980 | 1 | < 0.1% |
| 64979 | 1 | < 0.1% |
| 64978 | 1 | < 0.1% |
| 64977 | 1 | < 0.1% |
| 64976 | 1 | < 0.1% |
| 64975 | 1 | < 0.1% |
| Other values (97453) | 97453 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 97463 | 1 | |
| 97462 | 1 | |
| 97461 | 1 | |
| 97460 | 1 | |
| 97459 | 1 | |
| 97458 | 1 | |
| 97457 | 1 | |
| 97456 | 1 | |
| 97455 | 1 | |
| 97454 | 1 |
Fiscal_Year
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
| 2016 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 389852 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2016 |
|---|---|
| 2nd row | 2016 |
| 3rd row | 2016 |
| 4th row | 2016 |
| 5th row | 2016 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 97463 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2016 | 97463 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 97463 | |
| 0 | 97463 | |
| 1 | 97463 | |
| 6 | 97463 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 389852 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 97463 | |
| 0 | 97463 | |
| 1 | 97463 | |
| 6 | 97463 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 389852 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 97463 | |
| 0 | 97463 | |
| 1 | 97463 | |
| 6 | 97463 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 389852 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 97463 | |
| 0 | 97463 | |
| 1 | 97463 | |
| 6 | 97463 |
Budget_Type
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
| Metro Government Operations | |
|---|---|
| Metro Government Capital | 4837 |
Length
| Max length | 27 |
|---|---|
| Median length | 27 |
| Mean length | 26.851113 |
| Min length | 24 |
Characters and Unicode
| Total characters | 2616990 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Metro Government Capital |
|---|---|
| 2nd row | Metro Government Capital |
| 3rd row | Metro Government Capital |
| 4th row | Metro Government Capital |
| 5th row | Metro Government Capital |
Common Values
| Value | Count | Frequency (%) |
| Metro Government Operations | 92626 | |
| Metro Government Capital | 4837 | 5.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| metro | 97463 | |
| government | 97463 | |
| operations | 92626 | |
| capital | 4837 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 385015 | |
| t | 292389 | |
| n | 287552 | |
| r | 287552 | |
| o | 287552 | |
| 194926 | 7.4% | |
| a | 102300 | 3.9% |
| p | 97463 | 3.7% |
| i | 97463 | 3.7% |
| M | 97463 | 3.7% |
| Other values (7) | 487315 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2129675 | |
| Uppercase Letter | 292389 | 11.2% |
| Space Separator | 194926 | 7.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 385015 | |
| t | 292389 | |
| n | 287552 | |
| r | 287552 | |
| o | 287552 | |
| a | 102300 | 4.8% |
| p | 97463 | 4.6% |
| i | 97463 | 4.6% |
| m | 97463 | 4.6% |
| v | 97463 | 4.6% |
| Other values (2) | 97463 | 4.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 97463 | |
| G | 97463 | |
| O | 92626 | |
| C | 4837 | 1.7% |
Space Separator
| Value | Count | Frequency (%) |
| 194926 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2422064 | |
| Common | 194926 | 7.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 385015 | |
| t | 292389 | |
| n | 287552 | |
| r | 287552 | |
| o | 287552 | |
| a | 102300 | 4.2% |
| p | 97463 | 4.0% |
| i | 97463 | 4.0% |
| M | 97463 | 4.0% |
| m | 97463 | 4.0% |
| Other values (6) | 389852 |
Common
| Value | Count | Frequency (%) |
| 194926 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2616990 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 385015 | |
| t | 292389 | |
| n | 287552 | |
| r | 287552 | |
| o | 287552 | |
| 194926 | 7.4% | |
| a | 102300 | 3.9% |
| p | 97463 | 3.7% |
| i | 97463 | 3.7% |
| M | 97463 | 3.7% |
| Other values (7) | 487315 |
Agency_Name
Categorical
HIGH CORRELATION 
| Distinct | 37 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
| Community Services | |
|---|---|
| Office of Management & Budget | |
| Parks & Recreation | |
| Public Works & Assets | |
| Louisville Zoo | |
| Other values (32) |
Length
| Max length | 46 |
|---|---|
| Median length | 36 |
| Mean length | 22.142608 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2158085 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Public Works & Assets Department |
|---|---|
| 2nd row | Public Works & Assets Department |
| 3rd row | Public Works & Assets Department |
| 4th row | Public Works & Assets Department |
| 5th row | Public Works & Assets Department |
Common Values
| Value | Count | Frequency (%) |
| Community Services | 15787 | |
| Office of Management & Budget | 12401 | |
| Parks & Recreation | 11596 | |
| Public Works & Assets | 6266 | 6.4% |
| Louisville Zoo | 5925 | 6.1% |
| Louisville Free Public Library | 5180 | 5.3% |
| Louisville Metro Police Department | 5026 | 5.2% |
| Emergency Services | 4742 | 4.9% |
| Other Elected Officials | 3691 | 3.8% |
| Develop Louisville | 3627 | 3.7% |
| Other values (27) | 23222 |
Length
| Value | Count | Frequency (%) |
| 36837 | 12.1% | |
| louisville | 24956 | 8.2% |
| services | 23976 | 7.8% |
| of | 17003 | 5.6% |
| public | 16503 | 5.4% |
| community | 15787 | 5.2% |
| office | 13038 | 4.3% |
| management | 12437 | 4.1% |
| budget | 12401 | 4.1% |
| parks | 11596 | 3.8% |
| Other values (47) | 120931 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 259971 | 12.0% |
| 208002 | 9.6% | |
| i | 166453 | 7.7% |
| o | 132687 | 6.1% |
| t | 113463 | 5.3% |
| r | 112674 | 5.2% |
| s | 111340 | 5.2% |
| l | 101531 | 4.7% |
| c | 93272 | 4.3% |
| n | 93156 | 4.3% |
| Other values (35) | 765536 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1661267 | |
| Uppercase Letter | 251699 | 11.7% |
| Space Separator | 208002 | 9.6% |
| Other Punctuation | 37117 | 1.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 259971 | |
| i | 166453 | |
| o | 132687 | 8.0% |
| t | 113463 | 6.8% |
| r | 112674 | 6.8% |
| s | 111340 | 6.7% |
| l | 101531 | 6.1% |
| c | 93272 | 5.6% |
| n | 93156 | 5.6% |
| a | 79109 | 4.8% |
| Other values (11) | 397611 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 33728 | |
| L | 30441 | |
| S | 24013 | |
| C | 22031 | |
| M | 21519 | |
| O | 20420 | |
| D | 17384 | 6.9% |
| R | 13837 | 5.5% |
| B | 12401 | 4.9% |
| W | 11323 | 4.5% |
| Other values (10) | 44602 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 36645 | |
| ' | 244 | 0.7% |
| / | 228 | 0.6% |
Space Separator
| Value | Count | Frequency (%) |
| 208002 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1912966 | |
| Common | 245119 | 11.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 259971 | |
| i | 166453 | 8.7% |
| o | 132687 | 6.9% |
| t | 113463 | 5.9% |
| r | 112674 | 5.9% |
| s | 111340 | 5.8% |
| l | 101531 | 5.3% |
| c | 93272 | 4.9% |
| n | 93156 | 4.9% |
| a | 79109 | 4.1% |
| Other values (31) | 649310 |
Common
| Value | Count | Frequency (%) |
| 208002 | ||
| & | 36645 | 14.9% |
| ' | 244 | 0.1% |
| / | 228 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2158085 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 259971 | 12.0% |
| 208002 | 9.6% | |
| i | 166453 | 7.7% |
| o | 132687 | 6.1% |
| t | 113463 | 5.3% |
| r | 112674 | 5.2% |
| s | 111340 | 5.2% |
| l | 101531 | 4.7% |
| c | 93272 | 4.3% |
| n | 93156 | 4.3% |
| Other values (35) | 765536 |
Sub_Agency_Name
Text
| Distinct | 515 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
Length
| Max length | 70 |
|---|---|
| Median length | 55 |
| Mean length | 20.604383 |
| Min length | 6 |
Characters and Unicode
| Total characters | 2008165 |
|---|---|
| Distinct characters | 73 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 119 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Bridge Repair and Replacement |
|---|---|
| 2nd row | Bridge Repair and Replacement |
| 3rd row | Bridge Repair and Replacement |
| 4th row | Bridge Repair and Replacement |
| 5th row | Bridge Repair and Replacement |
| Value | Count | Frequency (%) |
| 25770 | 10.0% | |
| services | 23567 | 9.1% |
| community | 17189 | 6.7% |
| facilities | 12856 | 5.0% |
| fleet | 11338 | 4.4% |
| support | 10004 | 3.9% |
| operations | 6899 | 2.7% |
| maintenance | 6099 | 2.4% |
| public | 5608 | 2.2% |
| administrative | 5107 | 2.0% |
| Other values (793) | 133306 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 200782 | 10.0% |
| i | 197159 | 9.8% |
| 160280 | 8.0% | |
| t | 147326 | 7.3% |
| n | 124696 | 6.2% |
| r | 120317 | 6.0% |
| o | 107652 | 5.4% |
| s | 100349 | 5.0% |
| a | 97947 | 4.9% |
| c | 74402 | 3.7% |
| Other values (63) | 677255 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1560306 | |
| Uppercase Letter | 246232 | 12.3% |
| Space Separator | 160280 | 8.0% |
| Other Punctuation | 29971 | 1.5% |
| Decimal Number | 9279 | 0.5% |
| Close Punctuation | 917 | < 0.1% |
| Open Punctuation | 917 | < 0.1% |
| Dash Punctuation | 263 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 200782 | |
| i | 197159 | |
| t | 147326 | |
| n | 124696 | 8.0% |
| r | 120317 | 7.7% |
| o | 107652 | 6.9% |
| s | 100349 | 6.4% |
| a | 97947 | 6.3% |
| c | 74402 | 4.8% |
| l | 69498 | 4.5% |
| Other values (16) | 320178 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 45994 | |
| C | 31163 | |
| F | 30995 | |
| P | 20939 | |
| A | 18133 | 7.4% |
| O | 15678 | 6.4% |
| D | 12415 | 5.0% |
| M | 11268 | 4.6% |
| R | 10031 | 4.1% |
| B | 7776 | 3.2% |
| Other values (16) | 41840 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4540 | |
| 6 | 1737 | 18.7% |
| 5 | 865 | 9.3% |
| 9 | 816 | 8.8% |
| 0 | 478 | 5.2% |
| 2 | 366 | 3.9% |
| 4 | 321 | 3.5% |
| 8 | 70 | 0.8% |
| 3 | 64 | 0.7% |
| 7 | 22 | 0.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 25700 | |
| / | 1865 | 6.2% |
| ' | 1626 | 5.4% |
| , | 604 | 2.0% |
| . | 167 | 0.6% |
| # | 8 | < 0.1% |
| : | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 160280 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 917 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 917 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 263 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1806538 | |
| Common | 201627 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 200782 | 11.1% |
| i | 197159 | 10.9% |
| t | 147326 | 8.2% |
| n | 124696 | 6.9% |
| r | 120317 | 6.7% |
| o | 107652 | 6.0% |
| s | 100349 | 5.6% |
| a | 97947 | 5.4% |
| c | 74402 | 4.1% |
| l | 69498 | 3.8% |
| Other values (42) | 566410 |
Common
| Value | Count | Frequency (%) |
| 160280 | ||
| & | 25700 | 12.7% |
| 1 | 4540 | 2.3% |
| / | 1865 | 0.9% |
| 6 | 1737 | 0.9% |
| ' | 1626 | 0.8% |
| ) | 917 | 0.5% |
| ( | 917 | 0.5% |
| 5 | 865 | 0.4% |
| 9 | 816 | 0.4% |
| Other values (11) | 2364 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2008165 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 200782 | 10.0% |
| i | 197159 | 9.8% |
| 160280 | 8.0% | |
| t | 147326 | 7.3% |
| n | 124696 | 6.2% |
| r | 120317 | 6.0% |
| o | 107652 | 5.4% |
| s | 100349 | 5.0% |
| a | 97947 | 4.9% |
| c | 74402 | 3.7% |
| Other values (63) | 677255 |
DepartmentName
Text
MISSING 
| Distinct | 252 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 5230 |
| Missing (%) | 5.4% |
| Memory size | 761.6 KiB |
Length
| Max length | 42 |
|---|---|
| Median length | 33 |
| Mean length | 17.809558 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1642629 |
|---|---|
| Distinct characters | 67 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 15 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Finance & Administration |
|---|---|
| 2nd row | Finance & Administration |
| 3rd row | Finance & Administration |
| 4th row | Finance & Administration |
| 5th row | Finance & Administration |
| Value | Count | Frequency (%) |
| services | 15357 | 7.5% |
| 14634 | 7.2% | |
| management | 10262 | 5.0% |
| facilities | 9488 | 4.6% |
| self | 6151 | 3.0% |
| sufficiency | 6151 | 3.0% |
| maintenance | 5259 | 2.6% |
| operations | 4493 | 2.2% |
| policy | 3830 | 1.9% |
| advocacy | 3792 | 1.9% |
| Other values (349) | 124962 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 188832 | 11.5% |
| i | 159513 | 9.7% |
| n | 118293 | 7.2% |
| 112146 | 6.8% | |
| a | 110145 | 6.7% |
| t | 96229 | 5.9% |
| c | 87291 | 5.3% |
| r | 84182 | 5.1% |
| s | 71562 | 4.4% |
| o | 67989 | 4.1% |
| Other values (57) | 546447 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1300709 | |
| Uppercase Letter | 207512 | 12.6% |
| Space Separator | 112146 | 6.8% |
| Other Punctuation | 20010 | 1.2% |
| Decimal Number | 2246 | 0.1% |
| Open Punctuation | 3 | < 0.1% |
| Close Punctuation | 3 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 188832 | |
| i | 159513 | |
| n | 118293 | |
| a | 110145 | |
| t | 96229 | 7.4% |
| c | 87291 | 6.7% |
| r | 84182 | 6.5% |
| s | 71562 | 5.5% |
| o | 67989 | 5.2% |
| l | 67963 | 5.2% |
| Other values (16) | 248710 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 42527 | |
| M | 23990 | |
| A | 19565 | |
| F | 18942 | |
| P | 15706 | 7.6% |
| C | 10534 | 5.1% |
| O | 9127 | 4.4% |
| D | 8755 | 4.2% |
| R | 8271 | 4.0% |
| G | 7188 | 3.5% |
| Other values (13) | 42907 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 702 | |
| 2 | 451 | |
| 5 | 215 | 9.6% |
| 4 | 186 | 8.3% |
| 3 | 182 | 8.1% |
| 9 | 153 | 6.8% |
| 7 | 110 | 4.9% |
| 6 | 107 | 4.8% |
| 0 | 73 | 3.3% |
| 8 | 67 | 3.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 14633 | |
| / | 2407 | 12.0% |
| ' | 2060 | 10.3% |
| , | 907 | 4.5% |
| ? | 3 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 112146 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 3 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1508221 | |
| Common | 134408 | 8.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 188832 | |
| i | 159513 | 10.6% |
| n | 118293 | 7.8% |
| a | 110145 | 7.3% |
| t | 96229 | 6.4% |
| c | 87291 | 5.8% |
| r | 84182 | 5.6% |
| s | 71562 | 4.7% |
| o | 67989 | 4.5% |
| l | 67963 | 4.5% |
| Other values (39) | 456222 |
Common
| Value | Count | Frequency (%) |
| 112146 | ||
| & | 14633 | 10.9% |
| / | 2407 | 1.8% |
| ' | 2060 | 1.5% |
| , | 907 | 0.7% |
| 1 | 702 | 0.5% |
| 2 | 451 | 0.3% |
| 5 | 215 | 0.2% |
| 4 | 186 | 0.1% |
| 3 | 182 | 0.1% |
| Other values (8) | 519 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1642629 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 188832 | 11.5% |
| i | 159513 | 9.7% |
| n | 118293 | 7.2% |
| 112146 | 6.8% | |
| a | 110145 | 6.7% |
| t | 96229 | 5.9% |
| c | 87291 | 5.3% |
| r | 84182 | 5.1% |
| s | 71562 | 4.4% |
| o | 67989 | 4.1% |
| Other values (57) | 546447 |
MISSING 
| Distinct | 89 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 56189 |
| Missing (%) | 57.7% |
| Memory size | 761.6 KiB |
Length
| Max length | 43 |
|---|---|
| Median length | 38 |
| Mean length | 23.512599 |
| Min length | 8 |
Characters and Unicode
| Total characters | 970459 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Finance/Administrative Support |
|---|---|
| 2nd row | Finance/Administrative Support |
| 3rd row | Finance/Administrative Support |
| 4th row | Finance/Administrative Support |
| 5th row | Finance/Administrative Support |
| Value | Count | Frequency (%) |
| management | 8228 | 6.9% |
| facilities | 8174 | 6.9% |
| services | 7639 | 6.4% |
| 6542 | 5.5% | |
| administration | 5544 | 4.7% |
| care | 4968 | 4.2% |
| of | 4808 | 4.0% |
| grant | 4769 | 4.0% |
| continuum | 4744 | 4.0% |
| support | 4451 | 3.7% |
| Other values (136) | 59031 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 96884 | 10.0% |
| i | 95670 | 9.9% |
| n | 86352 | 8.9% |
| 77624 | 8.0% | |
| t | 75992 | 7.8% |
| a | 65111 | 6.7% |
| r | 56286 | 5.8% |
| s | 46957 | 4.8% |
| o | 42660 | 4.4% |
| m | 35129 | 3.6% |
| Other values (48) | 291794 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 761842 | |
| Uppercase Letter | 120769 | 12.4% |
| Space Separator | 77624 | 8.0% |
| Other Punctuation | 9009 | 0.9% |
| Dash Punctuation | 1183 | 0.1% |
| Open Punctuation | 16 | < 0.1% |
| Close Punctuation | 16 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 96884 | |
| i | 95670 | |
| n | 86352 | |
| t | 75992 | |
| a | 65111 | |
| r | 56286 | |
| s | 46957 | 6.2% |
| o | 42660 | 5.6% |
| m | 35129 | 4.6% |
| l | 31422 | 4.1% |
| Other values (16) | 129379 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 21503 | |
| F | 19090 | |
| C | 16973 | |
| M | 13399 | |
| A | 10442 | |
| G | 8170 | 6.8% |
| P | 8081 | 6.7% |
| E | 3728 | 3.1% |
| I | 3529 | 2.9% |
| V | 3178 | 2.6% |
| Other values (13) | 12676 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 6318 | |
| / | 2460 | 27.3% |
| ? | 224 | 2.5% |
| . | 6 | 0.1% |
| ' | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 77624 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1183 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 16 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 16 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 882611 | |
| Common | 87848 | 9.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 96884 | 11.0% |
| i | 95670 | 10.8% |
| n | 86352 | 9.8% |
| t | 75992 | 8.6% |
| a | 65111 | 7.4% |
| r | 56286 | 6.4% |
| s | 46957 | 5.3% |
| o | 42660 | 4.8% |
| m | 35129 | 4.0% |
| l | 31422 | 3.6% |
| Other values (39) | 250148 |
Common
| Value | Count | Frequency (%) |
| 77624 | ||
| & | 6318 | 7.2% |
| / | 2460 | 2.8% |
| - | 1183 | 1.3% |
| ? | 224 | 0.3% |
| ( | 16 | < 0.1% |
| ) | 16 | < 0.1% |
| . | 6 | < 0.1% |
| ' | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 970459 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 96884 | 10.0% |
| i | 95670 | 9.9% |
| n | 86352 | 8.9% |
| 77624 | 8.0% | |
| t | 75992 | 7.8% |
| a | 65111 | 6.7% |
| r | 56286 | 5.8% |
| s | 46957 | 4.8% |
| o | 42660 | 4.4% |
| m | 35129 | 3.6% |
| Other values (48) | 291794 |
Category
Categorical
IMBALANCE 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
| Contractual Services | |
|---|---|
| Supplies | |
| Direct Reimbursements | 2443 |
| Equipment/Capital Outlay | 1557 |
| Other Expenses | 308 |
| Other values (3) | 60 |
Length
| Max length | 24 |
|---|---|
| Median length | 20 |
| Mean length | 15.886306 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1548327 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Contractual Services |
|---|---|
| 2nd row | Contractual Services |
| 3rd row | Contractual Services |
| 4th row | Contractual Services |
| 5th row | Contractual Services |
Common Values
| Value | Count | Frequency (%) |
| Contractual Services | 59109 | |
| Supplies | 33986 | |
| Direct Reimbursements | 2443 | 2.5% |
| Equipment/Capital Outlay | 1557 | 1.6% |
| Other Expenses | 308 | 0.3% |
| Interdepartment Charges | 39 | < 0.1% |
| Personnel Services | 20 | < 0.1% |
| Interagency Charges | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| services | 59129 | |
| contractual | 59109 | |
| supplies | 33986 | |
| direct | 2443 | 1.5% |
| reimbursements | 2443 | 1.5% |
| equipment/capital | 1557 | 1.0% |
| outlay | 1557 | 1.0% |
| other | 308 | 0.2% |
| expenses | 308 | 0.2% |
| charges | 40 | < 0.1% |
| Other values (3) | 60 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 164696 | |
| t | 128201 | 8.3% |
| r | 123571 | 8.0% |
| a | 122969 | 7.9% |
| c | 120682 | 7.8% |
| i | 101115 | 6.5% |
| s | 98677 | 6.4% |
| u | 98652 | 6.4% |
| l | 96229 | 6.2% |
| S | 93115 | 6.0% |
| Other values (21) | 400420 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1320796 | |
| Uppercase Letter | 162497 | 10.5% |
| Space Separator | 63477 | 4.1% |
| Other Punctuation | 1557 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 164696 | |
| t | 128201 | |
| r | 123571 | |
| a | 122969 | |
| c | 120682 | |
| i | 101115 | |
| s | 98677 | |
| u | 98652 | |
| l | 96229 | |
| p | 71433 | 5.4% |
| Other values (11) | 194571 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 93115 | |
| C | 60706 | |
| D | 2443 | 1.5% |
| R | 2443 | 1.5% |
| O | 1865 | 1.1% |
| E | 1865 | 1.1% |
| I | 40 | < 0.1% |
| P | 20 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 63477 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1557 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1483293 | |
| Common | 65034 | 4.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 164696 | |
| t | 128201 | 8.6% |
| r | 123571 | 8.3% |
| a | 122969 | 8.3% |
| c | 120682 | 8.1% |
| i | 101115 | 6.8% |
| s | 98677 | 6.7% |
| u | 98652 | 6.7% |
| l | 96229 | 6.5% |
| S | 93115 | 6.3% |
| Other values (19) | 335386 |
Common
| Value | Count | Frequency (%) |
| 63477 | ||
| / | 1557 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1548327 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 164696 | |
| t | 128201 | 8.3% |
| r | 123571 | 8.0% |
| a | 122969 | 7.9% |
| c | 120682 | 7.8% |
| i | 101115 | 6.5% |
| s | 98677 | 6.4% |
| u | 98652 | 6.4% |
| l | 96229 | 6.2% |
| S | 93115 | 6.0% |
| Other values (21) | 400420 |
Sub_Category
Text
| Distinct | 398 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
Length
| Max length | 51 |
|---|---|
| Median length | 38 |
| Mean length | 23.131291 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2254445 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 31 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bridge Construction/ Repair Services |
|---|---|
| 2nd row | Bridge Construction/ Repair Services |
| 3rd row | Bridge Construction/ Repair Services |
| 4th row | Bridge Construction/ Repair Services |
| 5th row | Bridge Construction/ Repair Services |
| Value | Count | Frequency (%) |
| services | 31663 | 12.2% |
| supplies | 25805 | 10.0% |
| grant | 12303 | 4.7% |
| assistance | 7334 | 2.8% |
| community | 6966 | 2.7% |
| equipment | 6639 | 2.6% |
| office | 6108 | 2.4% |
| professional | 5907 | 2.3% |
| maintenance | 5821 | 2.2% |
| 5434 | 2.1% | |
| Other values (470) | 145353 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 241441 | 10.7% |
| i | 196788 | 8.7% |
| 161870 | 7.2% | |
| n | 157420 | 7.0% |
| s | 144319 | 6.4% |
| r | 134444 | 6.0% |
| t | 128618 | 5.7% |
| a | 126423 | 5.6% |
| c | 97837 | 4.3% |
| o | 95736 | 4.2% |
| Other values (55) | 769549 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1804642 | |
| Uppercase Letter | 263429 | 11.7% |
| Space Separator | 161870 | 7.2% |
| Other Punctuation | 22430 | 1.0% |
| Decimal Number | 763 | < 0.1% |
| Dash Punctuation | 663 | < 0.1% |
| Open Punctuation | 324 | < 0.1% |
| Close Punctuation | 324 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 241441 | |
| i | 196788 | |
| n | 157420 | |
| s | 144319 | 8.0% |
| r | 134444 | 7.4% |
| t | 128618 | 7.1% |
| a | 126423 | 7.0% |
| c | 97837 | 5.4% |
| o | 95736 | 5.3% |
| l | 91969 | 5.1% |
| Other values (16) | 389647 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 67872 | |
| C | 28165 | |
| A | 21830 | 8.3% |
| E | 19439 | 7.4% |
| P | 16605 | 6.3% |
| R | 15627 | 5.9% |
| M | 15489 | 5.9% |
| G | 13959 | 5.3% |
| O | 12121 | 4.6% |
| F | 10758 | 4.1% |
| Other values (12) | 41564 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 243 | |
| 1 | 170 | |
| 2 | 106 | |
| 5 | 53 | 6.9% |
| 3 | 43 | 5.6% |
| 4 | 37 | 4.8% |
| 6 | 33 | 4.3% |
| 9 | 30 | 3.9% |
| 8 | 28 | 3.7% |
| 7 | 20 | 2.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 16477 | |
| & | 4943 | 22.0% |
| , | 1010 | 4.5% |
Space Separator
| Value | Count | Frequency (%) |
| 161870 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 663 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 324 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 324 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2068071 | |
| Common | 186374 | 8.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 241441 | 11.7% |
| i | 196788 | 9.5% |
| n | 157420 | 7.6% |
| s | 144319 | 7.0% |
| r | 134444 | 6.5% |
| t | 128618 | 6.2% |
| a | 126423 | 6.1% |
| c | 97837 | 4.7% |
| o | 95736 | 4.6% |
| l | 91969 | 4.4% |
| Other values (38) | 653076 |
Common
| Value | Count | Frequency (%) |
| 161870 | ||
| / | 16477 | 8.8% |
| & | 4943 | 2.7% |
| , | 1010 | 0.5% |
| - | 663 | 0.4% |
| ( | 324 | 0.2% |
| ) | 324 | 0.2% |
| 0 | 243 | 0.1% |
| 1 | 170 | 0.1% |
| 2 | 106 | 0.1% |
| Other values (7) | 244 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2254445 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 241441 | 10.7% |
| i | 196788 | 8.7% |
| 161870 | 7.2% | |
| n | 157420 | 7.0% |
| s | 144319 | 6.4% |
| r | 134444 | 6.0% |
| t | 128618 | 5.7% |
| a | 126423 | 5.6% |
| c | 97837 | 4.3% |
| o | 95736 | 4.2% |
| Other values (55) | 769549 |
Stimulus_Type
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 97463 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 761.6 KiB |
Funding_Source
Text
| Distinct | 68 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
Length
| Max length | 57 |
|---|---|
| Median length | 12 |
| Mean length | 12.806973 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1248206 |
|---|---|
| Distinct characters | 64 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | County Road Aid |
|---|---|
| 2nd row | County Road Aid |
| 3rd row | County Road Aid |
| 4th row | County Road Aid |
| 5th row | County Road Aid |
| Value | Count | Frequency (%) |
| fund | 76489 | |
| general | 73941 | |
| shelter | 4968 | 2.3% |
| plus | 4968 | 2.3% |
| care | 4968 | 2.3% |
| caa | 2833 | 1.3% |
| 2015 | 2130 | 1.0% |
| federally | 1993 | 0.9% |
| funded | 1993 | 0.9% |
| go | 1899 | 0.9% |
| Other values (125) | 37157 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 183666 | |
| n | 161873 | |
| 115876 | ||
| r | 94935 | |
| l | 93064 | |
| a | 92335 | |
| u | 88561 | |
| d | 88365 | |
| F | 84320 | |
| G | 78022 | |
| Other values (54) | 167189 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 878145 | |
| Uppercase Letter | 235231 | 18.8% |
| Space Separator | 115876 | 9.3% |
| Decimal Number | 17095 | 1.4% |
| Dash Punctuation | 1702 | 0.1% |
| Other Punctuation | 133 | < 0.1% |
| Open Punctuation | 12 | < 0.1% |
| Close Punctuation | 12 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 183666 | |
| n | 161873 | |
| r | 94935 | |
| l | 93064 | |
| a | 92335 | |
| u | 88561 | |
| d | 88365 | |
| t | 17887 | 2.0% |
| i | 10883 | 1.2% |
| s | 10358 | 1.2% |
| Other values (15) | 36218 | 4.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 84320 | |
| G | 78022 | |
| C | 14572 | 6.2% |
| A | 11834 | 5.0% |
| P | 8542 | 3.6% |
| S | 8267 | 3.5% |
| M | 5444 | 2.3% |
| O | 3956 | 1.7% |
| E | 3748 | 1.6% |
| B | 3352 | 1.4% |
| Other values (13) | 13174 | 5.6% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4498 | |
| 0 | 4161 | |
| 2 | 3990 | |
| 5 | 3482 | |
| 4 | 592 | 3.5% |
| 9 | 273 | 1.6% |
| 3 | 89 | 0.5% |
| 6 | 6 | < 0.1% |
| 7 | 4 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 106 | |
| ' | 25 | 18.8% |
| . | 2 | 1.5% |
Space Separator
| Value | Count | Frequency (%) |
| 115876 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1702 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 12 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 12 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1113376 | |
| Common | 134830 | 10.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 183666 | |
| n | 161873 | |
| r | 94935 | |
| l | 93064 | |
| a | 92335 | |
| u | 88561 | |
| d | 88365 | |
| F | 84320 | |
| G | 78022 | |
| t | 17887 | 1.6% |
| Other values (38) | 130348 |
Common
| Value | Count | Frequency (%) |
| 115876 | ||
| 1 | 4498 | 3.3% |
| 0 | 4161 | 3.1% |
| 2 | 3990 | 3.0% |
| 5 | 3482 | 2.6% |
| - | 1702 | 1.3% |
| 4 | 592 | 0.4% |
| 9 | 273 | 0.2% |
| / | 106 | 0.1% |
| 3 | 89 | 0.1% |
| Other values (6) | 61 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1248206 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 183666 | |
| n | 161873 | |
| 115876 | ||
| r | 94935 | |
| l | 93064 | |
| a | 92335 | |
| u | 88561 | |
| d | 88365 | |
| F | 84320 | |
| G | 78022 | |
| Other values (54) | 167189 |
Vendor_Name
Text
| Distinct | 5177 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
Length
| Max length | 93 |
|---|---|
| Median length | 62 |
| Mean length | 21.84787 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2129359 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1884 ? |
|---|---|
| Unique (%) | 1.9% |
Sample
| 1st row | HIGHWAY SAFETY SERVICES |
|---|---|
| 2nd row | HIGHWAY SAFETY SERVICES |
| 3rd row | HIGHWAY SAFETY SERVICES |
| 4th row | HIGHWAY SAFETY SERVICES |
| 5th row | HIGHWAY SAFETY SERVICES |
| Value | Count | Frequency (%) |
| inc | 38584 | 11.4% |
| llc | 10630 | 3.2% |
| 7562 | 2.2% | |
| company | 6730 | 2.0% |
| co | 6257 | 1.9% |
| of | 5402 | 1.6% |
| depot | 4974 | 1.5% |
| office | 4446 | 1.3% |
| supply | 4202 | 1.2% |
| services | 3106 | 0.9% |
| Other values (5832) | 245296 |
Most occurring characters
| Value | Count | Frequency (%) |
| 239726 | ||
| E | 186192 | 8.7% |
| I | 164902 | 7.7% |
| N | 161952 | 7.6% |
| R | 136633 | 6.4% |
| C | 135675 | 6.4% |
| A | 135622 | 6.4% |
| O | 128276 | 6.0% |
| S | 124801 | 5.9% |
| L | 119874 | 5.6% |
| Other values (35) | 595706 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1873627 | |
| Space Separator | 239726 | 11.3% |
| Other Punctuation | 12440 | 0.6% |
| Decimal Number | 1734 | 0.1% |
| Dash Punctuation | 1196 | 0.1% |
| Open Punctuation | 318 | < 0.1% |
| Close Punctuation | 318 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 186192 | 9.9% |
| I | 164902 | 8.8% |
| N | 161952 | 8.6% |
| R | 136633 | 7.3% |
| C | 135675 | 7.2% |
| A | 135622 | 7.2% |
| O | 128276 | 6.8% |
| S | 124801 | 6.7% |
| L | 119874 | 6.4% |
| T | 106373 | 5.7% |
| Other values (16) | 473327 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 474 | |
| 9 | 267 | |
| 0 | 257 | |
| 8 | 217 | |
| 2 | 187 | 10.8% |
| 4 | 157 | 9.1% |
| 7 | 67 | 3.9% |
| 3 | 46 | 2.7% |
| 5 | 41 | 2.4% |
| 6 | 21 | 1.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 11755 | |
| . | 421 | 3.4% |
| / | 155 | 1.2% |
| ' | 100 | 0.8% |
| # | 9 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 239726 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1196 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 318 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 318 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1873627 | |
| Common | 255732 | 12.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 186192 | 9.9% |
| I | 164902 | 8.8% |
| N | 161952 | 8.6% |
| R | 136633 | 7.3% |
| C | 135675 | 7.2% |
| A | 135622 | 7.2% |
| O | 128276 | 6.8% |
| S | 124801 | 6.7% |
| L | 119874 | 6.4% |
| T | 106373 | 5.7% |
| Other values (16) | 473327 |
Common
| Value | Count | Frequency (%) |
| 239726 | ||
| & | 11755 | 4.6% |
| - | 1196 | 0.5% |
| 1 | 474 | 0.2% |
| . | 421 | 0.2% |
| ( | 318 | 0.1% |
| ) | 318 | 0.1% |
| 9 | 267 | 0.1% |
| 0 | 257 | 0.1% |
| 8 | 217 | 0.1% |
| Other values (9) | 783 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2129359 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 239726 | ||
| E | 186192 | 8.7% |
| I | 164902 | 7.7% |
| N | 161952 | 7.6% |
| R | 136633 | 6.4% |
| C | 135675 | 6.4% |
| A | 135622 | 6.4% |
| O | 128276 | 6.0% |
| S | 124801 | 5.9% |
| L | 119874 | 5.6% |
| Other values (35) | 595706 |
InvoiceID
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 78363 |
|---|---|
| Distinct (%) | 80.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1669279.6 |
| Minimum | 1534328 |
|---|---|
| Maximum | 1724826 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 761.6 KiB |
Quantile statistics
| Minimum | 1534328 |
|---|---|
| 5-th percentile | 1625181 |
| Q1 | 1644688.5 |
| median | 1669511 |
| Q3 | 1693566.5 |
| 95-th percentile | 1713899.9 |
| Maximum | 1724826 |
| Range | 190498 |
| Interquartile range (IQR) | 48878 |
Descriptive statistics
| Standard deviation | 28556.811 |
|---|---|
| Coefficient of variation (CV) | 0.017107267 |
| Kurtosis | -1.13785 |
| Mean | 1669279.6 |
| Median Absolute Deviation (MAD) | 24516 |
| Skewness | -0.003472627 |
| Sum | 1.6269299 × 1011 |
| Variance | 8.1549145 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1647870 | 60 | 0.1% |
| 1715811 | 42 | < 0.1% |
| 1651511 | 37 | < 0.1% |
| 1682576 | 37 | < 0.1% |
| 1674395 | 36 | < 0.1% |
| 1709592 | 35 | < 0.1% |
| 1655611 | 35 | < 0.1% |
| 1704776 | 35 | < 0.1% |
| 1695885 | 35 | < 0.1% |
| 1711564 | 35 | < 0.1% |
| Other values (78353) | 97076 |
| Value | Count | Frequency (%) |
| 1534328 | 3 | |
| 1562460 | 3 | |
| 1574774 | 3 | |
| 1576636 | 1 | < 0.1% |
| 1578381 | 3 | |
| 1582040 | 3 | |
| 1588962 | 1 | < 0.1% |
| 1589092 | 1 | < 0.1% |
| 1592147 | 2 | |
| 1593516 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1724826 | 3 | < 0.1% |
| 1724357 | 1 | < 0.1% |
| 1724262 | 1 | < 0.1% |
| 1722877 | 1 | < 0.1% |
| 1722871 | 3 | < 0.1% |
| 1722862 | 1 | < 0.1% |
| 1722859 | 20 | |
| 1722821 | 1 | < 0.1% |
| 1722806 | 1 | < 0.1% |
| 1722799 | 1 | < 0.1% |
InvoiceDt
Date
| Distinct | 673 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
| Minimum | 2009-12-01 05:00:00+00:00 |
|---|---|
| Maximum | 2016-07-31 03:59:59+00:00 |
InvoiceAmt
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 33924 |
|---|---|
| Distinct (%) | 34.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5259.9736 |
| Minimum | -111520.18 |
|---|---|
| Maximum | 3297990 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 812 |
| Negative (%) | 0.8% |
| Memory size | 761.6 KiB |
Quantile statistics
| Minimum | -111520.18 |
|---|---|
| 5-th percentile | 15.5 |
| Q1 | 90.91 |
| median | 315 |
| Q3 | 1046.05 |
| 95-th percentile | 14242.21 |
| Maximum | 3297990 |
| Range | 3409510.2 |
| Interquartile range (IQR) | 955.14 |
Descriptive statistics
| Standard deviation | 37983.479 |
|---|---|
| Coefficient of variation (CV) | 7.2212301 |
| Kurtosis | 1735.9058 |
| Mean | 5259.9736 |
| Median Absolute Deviation (MAD) | 270.37 |
| Skewness | 29.323209 |
| Sum | 5.126528 × 108 |
| Variance | 1.4427447 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 400 | 1688 | 1.7% |
| 300 | 842 | 0.9% |
| 50 | 637 | 0.7% |
| 100 | 585 | 0.6% |
| 315 | 574 | 0.6% |
| 30 | 562 | 0.6% |
| 125 | 557 | 0.6% |
| 500 | 353 | 0.4% |
| 600 | 351 | 0.4% |
| 200 | 318 | 0.3% |
| Other values (33914) | 90996 |
| Value | Count | Frequency (%) |
| -111520.18 | 1 | |
| -9465.41 | 1 | |
| -8477.91 | 1 | |
| -8068.5 | 2 | |
| -7580 | 1 | |
| -7319.69 | 1 | |
| -7040.16 | 1 | |
| -5831.44 | 1 | |
| -5672.35 | 1 | |
| -5172.68 | 1 |
| Value | Count | Frequency (%) |
| 3297990 | 1 | |
| 3102226.8 | 1 | |
| 2968700 | 1 | |
| 1938891.75 | 1 | |
| 1896241.22 | 1 | |
| 1721522.1 | 1 | |
| 1441361 | 1 | |
| 1369957 | 1 | |
| 1331341 | 1 | |
| 998639 | 1 |
DistributionAmt
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 39591 |
|---|---|
| Distinct (%) | 40.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2585.5885 |
| Minimum | -430882.42 |
|---|---|
| Maximum | 3297990 |
| Zeros | 17 |
| Zeros (%) | < 0.1% |
| Negative | 2838 |
| Negative (%) | 2.9% |
| Memory size | 761.6 KiB |
Quantile statistics
| Minimum | -430882.42 |
|---|---|
| 5-th percentile | 4.58 |
| Q1 | 49.13 |
| median | 210 |
| Q3 | 661.48 |
| 95-th percentile | 7740 |
| Maximum | 3297990 |
| Range | 3728872.4 |
| Interquartile range (IQR) | 612.35 |
Descriptive statistics
| Standard deviation | 28069.042 |
|---|---|
| Coefficient of variation (CV) | 10.855959 |
| Kurtosis | 5640.5785 |
| Mean | 2585.5885 |
| Median Absolute Deviation (MAD) | 190 |
| Skewness | 60.85704 |
| Sum | 2.5199921 × 108 |
| Variance | 7.8787111 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 400 | 1678 | 1.7% |
| 300 | 844 | 0.9% |
| 50 | 655 | 0.7% |
| 100 | 585 | 0.6% |
| 315 | 560 | 0.6% |
| 30 | 535 | 0.5% |
| 125 | 511 | 0.5% |
| 500 | 384 | 0.4% |
| 600 | 352 | 0.4% |
| 200 | 338 | 0.3% |
| Other values (39581) | 91021 |
| Value | Count | Frequency (%) |
| -430882.42 | 1 | |
| -317744.15 | 1 | |
| -300000 | 1 | |
| -267716.28 | 1 | |
| -225000 | 1 | |
| -132978.84 | 1 | |
| -125000 | 1 | |
| -111520.18 | 1 | |
| -100643.04 | 1 | |
| -100463.04 | 1 |
| Value | Count | Frequency (%) |
| 3297990 | 1 | |
| 3102226.8 | 1 | |
| 2968700 | 1 | |
| 1938891.75 | 1 | |
| 1896241.22 | 1 | |
| 1721522.1 | 1 | |
| 1441361 | 1 | |
| 1369957 | 1 | |
| 1331341 | 1 | |
| 998639 | 1 |
CheckID
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 45211 |
|---|---|
| Distinct (%) | 46.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 830373.01 |
| Minimum | 794385 |
|---|---|
| Maximum | 873879 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 761.6 KiB |
Quantile statistics
| Minimum | 794385 |
|---|---|
| 5-th percentile | 801133.1 |
| Q1 | 814039.5 |
| median | 830657 |
| Q3 | 846600 |
| 95-th percentile | 859409 |
| Maximum | 873879 |
| Range | 79494 |
| Interquartile range (IQR) | 32560.5 |
Descriptive statistics
| Standard deviation | 18790.533 |
|---|---|
| Coefficient of variation (CV) | 0.022629026 |
| Kurtosis | -1.1601541 |
| Mean | 830373.01 |
| Median Absolute Deviation (MAD) | 16134 |
| Skewness | -0.0049543999 |
| Sum | 8.0930645 × 1010 |
| Variance | 3.5308412 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 832858 | 96 | 0.1% |
| 803645 | 91 | 0.1% |
| 843111 | 87 | 0.1% |
| 840696 | 85 | 0.1% |
| 836201 | 85 | 0.1% |
| 809212 | 84 | 0.1% |
| 858735 | 80 | 0.1% |
| 829908 | 74 | 0.1% |
| 843783 | 74 | 0.1% |
| 815397 | 68 | 0.1% |
| Other values (45201) | 96639 |
| Value | Count | Frequency (%) |
| 794385 | 1 | |
| 794426 | 1 | |
| 794541 | 1 | |
| 794719 | 1 | |
| 794735 | 1 | |
| 794748 | 1 | |
| 794756 | 1 | |
| 794758 | 1 | |
| 794775 | 1 | |
| 794877 | 1 |
| Value | Count | Frequency (%) |
| 873879 | 1 | |
| 873873 | 2 | |
| 873830 | 1 | |
| 873820 | 1 | |
| 873387 | 2 | |
| 873380 | 1 | |
| 873362 | 1 | |
| 873217 | 1 | |
| 873205 | 1 | |
| 873032 | 2 |
CheckDt
Date
| Distinct | 309 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
| Minimum | 2015-07-02 03:59:59+00:00 |
|---|---|
| Maximum | 2016-09-23 03:59:59+00:00 |
CheckAmt
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 22752 |
|---|---|
| Distinct (%) | 23.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10624.83 |
| Minimum | 0 |
|---|---|
| Maximum | 3297990 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 761.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 51.3 |
| Q1 | 309.21 |
| median | 976.5 |
| Q3 | 4313.45 |
| 95-th percentile | 33578.25 |
| Maximum | 3297990 |
| Range | 3297990 |
| Interquartile range (IQR) | 4004.24 |
Descriptive statistics
| Standard deviation | 51854.389 |
|---|---|
| Coefficient of variation (CV) | 4.8804913 |
| Kurtosis | 565.69533 |
| Mean | 10624.83 |
| Median Absolute Deviation (MAD) | 858.9 |
| Skewness | 16.499 |
| Sum | 1.0355278 × 109 |
| Variance | 2.6888777 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 400 | 1691 | 1.7% |
| 300 | 799 | 0.8% |
| 100 | 414 | 0.4% |
| 50 | 376 | 0.4% |
| 600 | 369 | 0.4% |
| 500 | 309 | 0.3% |
| 550 | 213 | 0.2% |
| 150 | 211 | 0.2% |
| 200 | 205 | 0.2% |
| 250 | 201 | 0.2% |
| Other values (22742) | 92675 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 0.1 | 1 | < 0.1% |
| 0.13 | 4 | < 0.1% |
| 0.59 | 2 | < 0.1% |
| 0.61 | 5 | < 0.1% |
| 0.93 | 1 | < 0.1% |
| 1 | 14 | |
| 1.01 | 1 | < 0.1% |
| 1.05 | 1 | < 0.1% |
| 1.18 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3297990 | 1 | |
| 3102226.8 | 1 | |
| 2968700 | 1 | |
| 1938891.75 | 1 | |
| 1896241.22 | 1 | |
| 1721522.1 | 1 | |
| 1441361 | 1 | |
| 1433025 | 2 | |
| 1369957 | 1 | |
| 1098899.99 | 2 |
CheckVoidDt
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 761.6 KiB |
| 1900/01/01 05:00:00+00 |
|---|
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Characters and Unicode
| Total characters | 2144186 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1900/01/01 05:00:00+00 |
|---|---|
| 2nd row | 1900/01/01 05:00:00+00 |
| 3rd row | 1900/01/01 05:00:00+00 |
| 4th row | 1900/01/01 05:00:00+00 |
| 5th row | 1900/01/01 05:00:00+00 |
Common Values
| Value | Count | Frequency (%) |
| 1900/01/01 05:00:00+00 | 97463 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1900/01/01 | 97463 | |
| 05:00:00+00 | 97463 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1072093 | |
| 1 | 292389 | 13.6% |
| / | 194926 | 9.1% |
| : | 194926 | 9.1% |
| 9 | 97463 | 4.5% |
| 97463 | 4.5% | |
| 5 | 97463 | 4.5% |
| + | 97463 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1559408 | |
| Other Punctuation | 389852 | 18.2% |
| Space Separator | 97463 | 4.5% |
| Math Symbol | 97463 | 4.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1072093 | |
| 1 | 292389 | 18.8% |
| 9 | 97463 | 6.2% |
| 5 | 97463 | 6.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 194926 | |
| : | 194926 |
Space Separator
| Value | Count | Frequency (%) |
| 97463 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 97463 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2144186 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1072093 | |
| 1 | 292389 | 13.6% |
| / | 194926 | 9.1% |
| : | 194926 | 9.1% |
| 9 | 97463 | 4.5% |
| 97463 | 4.5% | |
| 5 | 97463 | 4.5% |
| + | 97463 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2144186 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1072093 | |
| 1 | 292389 | 13.6% |
| / | 194926 | 9.1% |
| : | 194926 | 9.1% |
| 9 | 97463 | 4.5% |
| 97463 | 4.5% | |
| 5 | 97463 | 4.5% |
| + | 97463 | 4.5% |
| ObjectId | InvoiceID | InvoiceAmt | DistributionAmt | CheckID | CheckAmt | Budget_Type | Agency_Name | Category | |
|---|---|---|---|---|---|---|---|---|---|
| ObjectId | 1.000 | -0.024 | -0.067 | -0.088 | -0.020 | 0.047 | 0.685 | 0.680 | 0.223 |
| InvoiceID | -0.024 | 1.000 | 0.008 | 0.004 | 0.992 | 0.017 | 0.042 | 0.044 | 0.025 |
| InvoiceAmt | -0.067 | 0.008 | 1.000 | 0.816 | 0.010 | 0.615 | 0.077 | 0.123 | 0.024 |
| DistributionAmt | -0.088 | 0.004 | 0.816 | 1.000 | -0.001 | 0.480 | 0.063 | 0.069 | 0.014 |
| CheckID | -0.020 | 0.992 | 0.010 | -0.001 | 1.000 | 0.029 | 0.045 | 0.057 | 0.026 |
| CheckAmt | 0.047 | 0.017 | 0.615 | 0.480 | 0.029 | 1.000 | 0.140 | 0.136 | 0.028 |
| Budget_Type | 0.685 | 0.042 | 0.077 | 0.063 | 0.045 | 0.140 | 1.000 | 0.736 | 0.232 |
| Agency_Name | 0.680 | 0.044 | 0.123 | 0.069 | 0.057 | 0.136 | 0.736 | 1.000 | 0.317 |
| Category | 0.223 | 0.025 | 0.024 | 0.014 | 0.026 | 0.028 | 0.232 | 0.317 | 1.000 |
| ObjectId | Fiscal_Year | Budget_Type | Agency_Name | Sub_Agency_Name | DepartmentName | Sub_DepartmentName | Category | Sub_Category | Stimulus_Type | Funding_Source | Vendor_Name | InvoiceID | InvoiceDt | InvoiceAmt | DistributionAmt | CheckID | CheckDt | CheckAmt | CheckVoidDt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1643303 | 2015/09/30 03:59:59+00 | 5415.0 | 5415.0 | 815529 | 2015/10/26 03:59:59+00 | 7580.00 | 1900/01/01 05:00:00+00 |
| 1 | 2 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1627006 | 2015/07/31 03:59:59+00 | 5595.5 | 5595.5 | 807288 | 2015/09/14 03:59:59+00 | 5595.50 | 1900/01/01 05:00:00+00 |
| 2 | 3 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1634875 | 2015/08/31 03:59:59+00 | 5595.5 | 5595.5 | 809808 | 2015/09/25 03:59:59+00 | 7829.40 | 1900/01/01 05:00:00+00 |
| 3 | 4 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1619191 | 2015/06/30 03:59:59+00 | 5415.0 | 5415.0 | 801824 | 2015/08/12 03:59:59+00 | 5415.00 | 1900/01/01 05:00:00+00 |
| 4 | 5 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1675119 | 2016/01/31 05:00:00+00 | 5595.5 | 5595.5 | 836449 | 2016/02/25 05:00:00+00 | 6948.15 | 1900/01/01 05:00:00+00 |
| 5 | 6 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1675126 | 2016/01/31 05:00:00+00 | 62.0 | 62.0 | 836449 | 2016/02/25 05:00:00+00 | 6948.15 | 1900/01/01 05:00:00+00 |
| 6 | 7 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1668154 | 2015/12/31 05:00:00+00 | 5595.5 | 5595.5 | 830801 | 2016/01/25 05:00:00+00 | 7730.65 | 1900/01/01 05:00:00+00 |
| 7 | 8 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1659333 | 2015/11/30 05:00:00+00 | 5415.0 | 5415.0 | 826709 | 2015/12/28 05:00:00+00 | 10188.50 | 1900/01/01 05:00:00+00 |
| 8 | 9 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1682886 | 2016/02/29 05:00:00+00 | 5234.5 | 5234.5 | 841617 | 2016/03/25 03:59:59+00 | 7597.85 | 1900/01/01 05:00:00+00 |
| 9 | 10 | 2016 | Metro Government Capital | Public Works & Assets Department | Bridge Repair and Replacement | NaN | NaN | Contractual Services | Bridge Construction/ Repair Services | NaN | County Road Aid | HIGHWAY SAFETY SERVICES | 1692149 | 2016/03/31 03:59:59+00 | 5595.5 | 5595.5 | 846620 | 2016/04/25 03:59:59+00 | 9616.00 | 1900/01/01 05:00:00+00 |
| ObjectId | Fiscal_Year | Budget_Type | Agency_Name | Sub_Agency_Name | DepartmentName | Sub_DepartmentName | Category | Sub_Category | Stimulus_Type | Funding_Source | Vendor_Name | InvoiceID | InvoiceDt | InvoiceAmt | DistributionAmt | CheckID | CheckDt | CheckAmt | CheckVoidDt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97453 | 97454 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | Custodial Supplies | NaN | General Fund | SOUTHWEST JEFFERSON INC | 1700693 | 2016/04/22 03:59:59+00 | 812.40 | 720.60 | 850473 | 2016/05/17 03:59:59+00 | 1292.00 | 1900/01/01 05:00:00+00 |
| 97454 | 97455 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | Custodial Supplies | NaN | General Fund | SOUTHWEST JEFFERSON INC | 1700693 | 2016/04/22 03:59:59+00 | 812.40 | 91.80 | 850473 | 2016/05/17 03:59:59+00 | 1292.00 | 1900/01/01 05:00:00+00 |
| 97455 | 97456 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | Custodial Supplies | NaN | General Fund | SOUTHWEST JEFFERSON INC | 1700694 | 2016/04/22 03:59:59+00 | 479.60 | 479.60 | 850473 | 2016/05/17 03:59:59+00 | 1292.00 | 1900/01/01 05:00:00+00 |
| 97456 | 97457 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | Custodial Supplies | NaN | General Fund | SOUTHWEST JEFFERSON INC | 1720639 | 2016/06/27 03:59:59+00 | 812.40 | 812.40 | 862237 | 2016/07/22 03:59:59+00 | 812.40 | 1900/01/01 05:00:00+00 |
| 97457 | 97458 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | Custodial Supplies | NaN | General Fund | SOUTHWEST JEFFERSON INC | 1713236 | 2016/06/10 03:59:59+00 | 719.40 | 719.40 | 859070 | 2016/07/05 03:59:59+00 | 719.40 | 1900/01/01 05:00:00+00 |
| 97458 | 97459 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | Custodial Supplies | NaN | General Fund | SOUTHWEST JEFFERSON INC | 1711246 | 2016/05/27 03:59:59+00 | 541.60 | 541.60 | 857295 | 2016/06/24 03:59:59+00 | 541.60 | 1900/01/01 05:00:00+00 |
| 97459 | 97460 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | Custodial Supplies | NaN | General Fund | SOUTHWEST JEFFERSON INC | 1714049 | 2016/06/03 03:59:59+00 | 541.60 | 541.60 | 858046 | 2016/06/28 03:59:59+00 | 541.60 | 1900/01/01 05:00:00+00 |
| 97460 | 97461 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | First Aid Supplies | NaN | General Fund | GRAINGER INDUSTRIAL SUPPLY | 1676519 | 2016/02/04 05:00:00+00 | 95.85 | 95.85 | 836829 | 2016/02/29 05:00:00+00 | 3942.68 | 1900/01/01 05:00:00+00 |
| 97461 | 97462 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | First Aid Supplies | NaN | General Fund | GRAINGER INDUSTRIAL SUPPLY | 1644089 | 2015/10/05 03:59:59+00 | 95.48 | 95.48 | 816769 | 2015/10/30 03:59:59+00 | 115.36 | 1900/01/01 05:00:00+00 |
| 97462 | 97463 | 2016 | Metro Government Operations | Louisville Zoo | Visitor Services | Visitor Services | NaN | Supplies | First Aid Supplies | NaN | General Fund | GRAINGER INDUSTRIAL SUPPLY | 1627704 | 2015/08/04 03:59:59+00 | 250.63 | 250.63 | 805212 | 2015/08/31 03:59:59+00 | 1574.76 | 1900/01/01 05:00:00+00 |